|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | UDM Question -workout | |
| NYMike 7/19/2022 11:38:21 AM | How would I create a UDM in SQL that would identify a horse with a workout of a specific distance, say 3F, since the last race? Thanks, Mike
| |
| jeff 7/30/2022 12:10:48 PM | Never did the programming to enable that in a UDM. (And probably won't.) That said, among the new TDx factors you'll find: TDX_WOBRILL_BEST10 TDX_WOBRILL_COMP TDX_WOBRILL_CX10 TDX_WODIST_BEST10 TDX_WODIST_COMP TDX_WODIST_CX10 TDX_WOFAST_BEST10 TDX_WOFAST_COMP TDX_WOFAST_CX10 TDX_WOFIT_BEST10 TDX_WOFIT_COMP TDX_WOFIT_CX10 TDX_WOPCT_BEST10 TDX_WOPCT_COMP TDX_WOPCT_CX10 TDX_WODIST_BEST10 is generated by an algorithm that applies a user defined time decay half life to the distance in yards for each of a horse's 10 most recent workouts. Factor numeric value for the work that scores out the highest among all 10 becomes that horse's TDX_WODIST_BEST10. TDX_WODIST_COMP is a composite generated from the time decayed distance of a horse's 10 most recent works. TDX_WODIST_CX10 while similar to the composite, is generated by a different scoring algorithm. The resulting factor value ends up being close to an average of distance worked while breaking ties. The TDX_WODIST's are pretty good factor in their own right but they aren't in my current sql factor setup. In my sql factor setup, I instead opted to go with: TDX_WOFIT_BEST10 TDX_WOFIT_CX10 TDX_WOPCT_BEST10 TDX_WOPCT_CX10. TDX_WOFIT is generated by an algorithm that scores both speed in fps (workout brilliance) of each work and work distance. Imo, TDX_WOFIT is a bit stronger (more significant) than scoring distance alone. TDX_WOPCT is generated by an algorithm that applies a user defined half life to time decay "rank" among number worked. Also as an Fyi, I worked all of the above TDx WoData factors into my UPR and UserFactor groupnames. -jp . ~Edited by: jeff on: 7/30/2022 at: 12:10:48 PM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |